aaronb
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Extract transaction sets from text data
Charles, If it helps the content is coming in as just a text file which I am then parsing using a CSV delimiter snap with “*” as the delimiter in this case. The issue I run into is that in the file each ST to SE block of data needs to be kept together as it contains invoice header and invoice detail data. The only context of what invoice line detail goes with which header is that they both reside in the same ST to SE block. Hopefully that makes sense or helps clarify.2.5KViews0likes1CommentExtract transaction sets from text data
HI I have the below 810 EDI formatted text data that I am needing some assistance with. Each transaction set begins with “ST” and ends with “SE”. I am need to extract each of the two transaction sets individually so I keep each “set” together for further manipulation downstream. Any thoughts on how this can be done in the most efficient manner? Thanks in advance ST*810*40001~ BIG*20211013*27383638*****DI~ REF*CR*1174143~ REF*VN*EDDON20~ REF*OI*27383638~ N1*SF*EDWARD DON & COMPANY - FLORIDA*91*EDDON20~ N3*11500 MIRAMAR PARKWAY~ N4*MIRAMAR*FL*33025~ N1*ST*TAP AVENTURA LLC*92*1174143~ N3*19501 BISCAYNE BLVD #1960~ N4*MIAMI*FL*33180~ IT1*000010*1.000*PK*89.95**VN*000000000001102902~ PID*F****PLATE RND 6" KILN PEPPER~ IT1*000030*1.000*CS*116.61**VN*000000000001144794~ PID*F****COASTER PULPBOARED OFF WHT TAP 42~ IT1*000040*3.000*CS*31.68**VN*000000000001041937~ PID*F****LINER 37X50 1.5MIL LD 44GAL SUREFIT BLK~ IT1*000060*3.000*CS*66.05**VN*000000000001160905~ PID*F****CONT HNG 9X9" LITES PP BLK~ IT1*000080*1.000*CS*32.94**VN*2P1211~ PID*F****TISSUE BATH 2 PLY MINI JUMBO TORK ADVANC~ IT1*000090*1.000*EA*71.50**VN*000000000001127594~ PID*F****DISPENSER TOWEL TORK INTUITION BLACK~ IT1*000110*1.000*CS*28.88**VN*000000000001174889~ PID*F****SHEET PAPER 8X12" RECYCLED KRAFT~ TDS*67738~ TXI*SU*44.31~ CTT*7**165.311*LB~ SE*29*40001~ ST*810*40002~ BIG*20210901*27181502**TARA***DI~ REF*CR*1106203~ REF*VN*EDDON20~ REF*OI*27181502~ N1*SF*EDWARD DON & COMPANY - FLORIDA*91*EDDON20~ N3*11500 MIRAMAR PARKWAY~ N4*MIRAMAR*FL*33025~ N1*ST*TAP 42*92*1106203~ N3*1411 SOUTH ANDREWS AVE~ N4*FORT LAUDERDALE*FL*33316~ IT1*000010*1.000*CS*76.34**VN*000000000001119000~ PID*F****CUP COFFEE 12 OZ CERAMIC BLK~ IT1*000020*1.000*EA*43.70**VN*SH01~ PID*F****SHIPPING~ TDS*12844~ TXI*SU*8.4~ CTT*2**31.000*LB~ SE*19*40002~Re: Retrieve Filename into Mapper from Box Read
@skatpally or @cstewart I am working through this same type of issue and have been able to replicate everything but I found that the data within the CSV file/s are not matching to their respective filenames after the join step? Is there something I have wrong on my join by chance?1.8KViews0likes0CommentsGet all paginated query results
Hi All, I have a scenario that I am hoping someone here can help with… I need to iterate through paginated results which I know is easily done when using a REST GET call. However in my case I have to use a REST POST call. Essentially I query records and get the xml response below. <control> <status>success</status> <senderid>profitbuilders</senderid> <controlid>1557344142</controlid> <uniqueid>false</uniqueid> <dtdversion>3.0</dtdversion> </control> <operation> <authentication> <status>success</status> <userid>ExtUser|profitbuilders|xml_gateway</userid> <companyid>profitbuilders-testing</companyid> <locationid></locationid> <sessiontimestamp>2019-05-08T12:36:35-07:00</sessiontimestamp> </authentication> <result> <status>success</status> <function>readByQuery</function> <controlid>dee09739-d797-4736-a739-4315952e777a</controlid> <data listtype="apbill" count="10" totalcount="171" numremaining="**161**" resultId="**7765623336XNMvwwTuKPplbSqLP3LCtgAAAAY4**"> <apbill> <RECORDNO>140</RECORDNO> </apbill> <apbill> <RECORDNO>195</RECORDNO> </apbill> <apbill> <RECORDNO>200</RECORDNO> </apbill> <apbill> <RECORDNO>25</RECORDNO> </apbill> <apbill> <RECORDNO>152</RECORDNO> </apbill> <apbill> <RECORDNO>175</RECORDNO> </apbill> <apbill> <RECORDNO>213</RECORDNO> </apbill> <apbill> <RECORDNO>4</RECORDNO> </apbill> <apbill> <RECORDNO>205</RECORDNO> </apbill> <apbill> <RECORDNO>62</RECORDNO> </apbill> </data> </result> </operation> I then have to make another similar POST call shown below that references the result id highlighted above like this. <readMore> <resultId>7765623332WU1hh8CoA4QAAHxI9i8AAAAA5</resultId> </readMore> I have to repeat this POST call until num remaining = 0 Again this would be very easy if the referenced API used a standard GET call instead of having to use POST. Any thoughts or help is much appreciated.2.3KViews0likes1CommentNested ternary expression using Match operator
Expression: parseFloat($InvoiceTotal1.trim()) < 0 && $CategoryDescription.trim() == “INVOICE ADJUSTMENTS” ? parseFloat($InvoiceAdjustments.trim()) : (parseFloat($InvoiceTotal1.trim()) > 0 && $CategoryDescription.trim() == “INVOICE ADJUSTMENTS” ? parseFloat($InvoiceAdjustments.trim()) : (parseFloat($InvoiceTotal1.trim()) < 0 ? parseFloat($CategorySalesValue.trim())+parseFloat($CategoryDiscountAllowance.trim()) : parseFloat($CategorySalesValue.trim())+parseFloat($CategorySalesTax.trim()))) Description: Hi, I am using the above ternary expression to handle essntially four different conditions. I used a ternary expression for timing purposes but long term I think it would make sense to use the match operator or something similar. I explored this option but never could get the syntax correct. If anyone has some experience with something similar that they could help point me in the right direction I would greatly appreciate it! Thank you Sample: See above Release used: 4.164.2KViews0likes2Comments