Or you could use ALINES.
m.ctext=[field 1|field 2||field 4|field 5|field 6] ?ALINES(anarray,m.ctext,2,[|]) DISPLAY MEMORY LIKE anarray*
--
rk -----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Matt Wiedeman Sent: Thursday, April 20, 2017 10:58 AM To: profox@leafe.com Subject: Text file import
Hello everyone,
I need to setup a job to import a pipe delimited text file. This is easy enough but one of the fields is larger than 254 characters. If I use a memo field, it does not import that field. I started to setup a routine to step through each character and store the fields manually but I would rather not do it that way.
Does anyone have a function or tip they can share to resolve this situation?