I'm confused by the code, above. If you are using tab as your column delimiter, then you wouldn't replace it with a space, since your tsv/csv files would have tabs in them when they were exported, originally. In any case, when you are going to replace a character with another character, you should make sure that the character you are replacing it to either a) does not have any special meaning (e.g. a delimiter) or b) if it does have a special meaning that it does not appear in the data, already. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: CSV to TSV (was Re: Tools & techniques for one-off consolidation of multiple 'similar' CSV files?)
Mike Kerner via use-livecode Tue, 05 Apr 2022 09:11:34 -0700
- Tools & techniques for one-off consoli... Keith Clarke via use-livecode
- Re: Tools & techniques for one-of... Mike Kerner via use-livecode
- Re: Tools & techniques for on... Bob Sneidar via use-livecode
- Re: Tools & techniques fo... Craig Newman via use-livecode
- Re: Tools & techniques fo... Bob Sneidar via use-livecode
- CSV to TSV (was Re: Tools & t... Keith Clarke via use-livecode
- Re: CSV to TSV (was Re: Tools... Mike Kerner via use-livecode
- Re: CSV to TSV (was Re: T... Keith Clarke via use-livecode
- Re: CSV to TSV (was Re: Tools... Alex Tweedly via use-livecode
- Re: CSV to TSV (was Re: T... Keith Clarke via use-livecode
- Re: Tools & techniques for one-of... Ben Rubinstein via use-livecode