Yep, you can't see the embedded tabs and CRs. He had asked me to figureout a way of doing it, took a long time before I figured it out, but as soon as I did we put that in a whole bunch of places! Like you, in some places I usethe SSub to do operations on each one.
Karen -----Original Message----- From: Doug Hamilton <[email protected]> To: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Thu, Jul 15, 2021 2:46 pm Subject: Re: [RBASE-L] - How to load 1 col of text values from Excel into a table? That's it! Thanks Karen! I pasted 14 rows from the ss and INSERTED 14 rows into the temp table. Apparently the Tabs & CRLFs are hidden? Whatever... It works - needed a quick fix and that did it. On 7/15/2021 2:12 PM, 'Karen Tellef' via RBASE-L wrote: SET VAR vTab = (CHAR(009)) SET VAR vPartList = (SRPL(.vPartList, .vTab, ",", 0)) SET VAR vCRLF = (CHAR(013) + CHAR(010)) SET VAR vPartList = (SRPL(.vPartList, .vCRLF, ",", 0)) Parse and INSERT: SET VAR vItemCount INTEGER = (ITEMCNT(.vItemCodes)) SET VAR vCurrentPos INTEGER = 1 WHILE vCurrentPos < vItemCount THEN SET VAR vItemCode = (SSUB(.vItemCodes,.vCurrentPos)) INSERT INTO tVORReport (Item) VALUES (.vItemCode) SET VAR vCurrentPos = (vCurrentPos + 1) ENDWHILE | | This email has been checked for viruses by Avast antivirus software. www.avast.com | -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/3979b234-b92a-973b-beb7-e3d27a1bcf0e%40wi.rr.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/304465201.272024.1626378819539%40mail.yahoo.com.
