Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have the following fields in my database:
ID History (memo datatype in access db)
43204000 | 02/01/2006 09:05 J1 Inquiry Received 12/01/2006 13:13 J1 Pricing Completed 12/01/2006 13:13 J1 Quotation Produced - Ref XXXXX |
43205000 | 02/01/2006 09:07 J1 Inquiry Received 07/01/2006 10:28 J1 Pricing Completed 07/01/2006 10:29 J1 Quotation Produced - Ref XXXXXX 05/02/2006 18:19 SU Order Received 06/03/2006 09:38 JL Shipment Recorded #12470 |
I want to extract the dates for each status of order in the History for every ID on load.
I tired a lot to split using trim, subfield and chr(13) but it doesnot seem to work.
It would be great if anyone could help me out.Thanks a lot in advance.
Neima
Subfield should work. What happens if you do a
Load *,
Subfield(History,chr(10)) as SubHistory,
index(History,chr(10)),
index(History,chr(13));
SQL SELECT
ID,
History
FROM <TableName>;
HIC
Subfield should work. What happens if you do a
Load *,
Subfield(History,chr(10)) as SubHistory,
index(History,chr(10)),
index(History,chr(13));
SQL SELECT
ID,
History
FROM <TableName>;
HIC
I had only used chr(13).This works.Thanks a lot HIC.Have read many of your blogs.You are an inspiration to newbies like us.Thanks again