Whoops, forgot one line for sure... > Job 2 is to scan for quotes where readingString = true > and convert it to numtochar (4) > false into readingString > put empty into prevCH > repeat for each char CH in textBlock > if (CH is ",") and prevCH is q then > put false into readingString > put prevCH after newTextBlock > else > put numtochar (3) after newTextBlock > end if > if (CH is q) and prevCH is "," then > put false into readingString > end if > end repeat put CH into prevCH --- IMPORTANT > put CH after newTextBlock >
On 6/22/07 4:04 PM, "Jim Ault" <[EMAIL PROTECTED]> wrote: >> My problem is, i do not know, how can i read the file and detect each item of >> a line, as the items are sepearated by comma and the textfield/items could >> contain comma, too. How can i tell Revolution to ignore the comma in the >> "tesxtarea of an item" > > Short answer is to ask for a tab delim file instead. > > I have had to do this task before because we bought industry data that was > only available in CSV. Probably the worst format ever, but everyone seems > to use it. Tab delim is sooo much better, > > Part of the situation is: > text values with quotes surrounding > and > text values with embedded quotes > text values with embedded commas > > Embedded commas are problematic in any solution you program. > --> Fuji Cleaning Cartridge für DLT Streamer, retail > > The basic concept you need to keep is that you are building a character > scanner with flags to represent conditions. > > A reading value w/o quote, thus number (commas illegal now) > B reading value w/ quote as first char, thus string > C found quote followed by comma, thus end of string > D found quote not followed by comma, thus embedded quote > E reading string, found comma before closing quote, thus embedded comma _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
