Parse txt file

Question

Parse txt file

May 31, 2022 at 11:38 pm

This was removed by the editor as SPAM

Viewing 11 posts - 46 through 55 (of 55 total)

You must be logged in to reply to this topic. Login to reply

Bruin SSCrazy Points: 2091 More actions · Answer 1

Thanks for responses... I think the problem is data related... When I run the following query I finding some of the records starting with

/* and

/*

Where it's failing is the 4th record where the eye-catcher /* has a space before /*

Select * from

PSFileOrder

where

psfile not like '%:%' and psfile <> ' '

and psfile like ('% /*%')

frederico_fonseca SSCoach Points: 16171 More actions · Answer 2

then its time for you to read the manuals - keyword TRIM

Bruin SSCrazy Points: 2091 More actions · Answer 3

I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by Jeff works as expected...

Thanks to you both and sorry for some of posts I really appreciate your help..

Jeff,

Will try to make sure I follow the rules and suggestions when asking for help.

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 4

Do all of the files have a similar issue? Perhaps you need to tweak the code to handle the anomalies. Frederico offered a hint about that above.

And, no... they're not rules. They're just common sense. We can't help you if you come in and say you need help fixing the car but won't even provide a picture of the problem never mind let us look at the car. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 5

Jeff Moden wrote:

~~Do all of the files have a similar issue? Perhaps you need to tweak the code to handle the anomalies. Frederico offered a hint about that above.~~
And, no... they're not rules. They're just common sense. We can't help you if you come in and say you need help fixing the car but won't even provide a picture of the problem never mind let us look at the car. 😉

Edit... was in a hurry and misread your post. You fixed the issue at the source, which is an even better solution. Well done there!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 6

Bruin wrote:

I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by Jeff works as expected...

If you have control over the source creation why not just create it in a more usable format in the first place..... >.<

Jeffrey Williams SSC Guru Points: 90313 More actions · Answer 7

Jeff Moden wrote:

Jeff Moden wrote:
~~Do all of the files have a similar issue? Perhaps you need to tweak the code to handle the anomalies. Frederico offered a hint about that above.~~
And, no... they're not rules. They're just common sense. We can't help you if you come in and say you need help fixing the car but won't even provide a picture of the problem never mind let us look at the car. 😉
Edit... was in a hurry and misread your post. You fixed the issue at the source, which is an even better solution. Well done there!

If he can fix the output at the source - then it shouldn't be too difficult to fix that source to output data that is much easier to parse. Even if this is just being output from a bunch of print statements to a console - you can add a line of text output that is formatted as a delimited list of elements or even create a separate file.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 8

ZZartin wrote:

Bruin wrote:
I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by Jeff works as expected...
If you have control over the source creation why not just create it in a more usable format in the first place..... >.<

Major chicken dinner right there. 😀 It's funny, I had that same revelation just a wee bit ago and came here to post nearly the same words as what you posted above. Writing the data directly to a staging table would be even better but at least a more normal, "columunised" TSV would make life a whole lot easier.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Bruin SSCrazy Points: 2091 More actions · Answer 9

What I meant was after this file was generated I could alter the output to correct the issues. The initial creation of the file was some generated process from the App which I have "No Control".

thx

Jeffrey Williams SSC Guru Points: 90313 More actions · Answer 10

Bruin wrote:

What I meant was after this file was generated I could alter the output to correct the issues. The initial creation of the file was some generated process from the App which I have "No Control".
thx

Then that really isn't a solution to the problem - since you would need someone to manually 'fix' the file every time you want to process.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs