Thanks Tom works a treat!
Sorry to keep adding to it how would I get the line immediately successing the line that matches, I've tried the below but it's not liking it.
DEFINE VARIABLE lineInDateString AS CHAR NO-UNDO.
DEFINE VARIABLE lineInBody AS CHAR NO-UNDO.
DEFINE VARIABLE lineAfterMatch...
Thanks I've got this far which is the first bit you mentioned but I'm not sure where to go next as I'm not familiar with pattern matching and longchar's.
I want to do something like if line contains "Lines:" grab the value immediately preceding that. It also need to grab the Date & Time from...
Hi,
I'm attempting to import a text file into a temp table so I can perform some calculations on data held within it. I'm struggling as I've only managed to upload a file in the past where only 1 delimiter was needed and the columns were laid out nicely.
Basically I have a temp table at the...
Thanks for all the feedback guys being a massive help :)
I've tested out Cringer's method and seen a ~50% speed increase which is great although on a 50 record test it's still taking 26 seconds as opposed to 49 seconds before, when I'm expecting ~1-2 seconds run time.
Tom I tried to...
Hi,
I'm wondering is someone can help me speed up an upload of data I'm trying to perform. I'm new to this so haven't much experience but I've managed to piece together the below which works fine although I would expect it to complete within a few seconds instead it's taking 45 seconds a go...
Almost there! Not showing any data now, so the browse part appears to be working and it outputs the label names at the top but no data.
IF outputSelection = "terminalOption" THEN DO:
DEFINE FRAME terminal-frame WITH SIZE 80 BY 15 ROW 7 COLUMN 1.
DEFINE QUERY terminal-display FOR...
the iNewStk and deCostAdj are variables that I created for this program so they don't lie within any database/table.
DEFINE VARIABLE deCostAdj AS DECIMAL NO-UNDO FORMAT "->>>9.99" LABEL "Cost Value"
INIT "0.00".
DEFINE VARIABLE iNewStk AS INTEGER NO-UNDO FORMAT "->>>>9" LABEL "New Stk"
INIT...
Thank you for all your help so far, I'm getting this error for the variables I'm creating in the ADD-LIKE-COLUMN statements:
iNewStk in ADD-LIKE-COLUMN must have a table qualifier. (9158)
IF outputSelection = "terminalOption" THEN DO:
DEFINE FRAME terminal-frame WITH SIZE 27 BY 15 ROW 7...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.