Skip a line in CSV File

[Bluemoon]

Hi I'm using the read from csv file and looping it. The problem I have is that I want to skipm a line in the file when it produces a certain result. How do I produce a script that will go to the next line in the text file using an If then statement

[trentonponder]

Originally Posted by Bluemoon

Hi I'm using the read from csv file and looping it. The problem I have is that I want to skipm a line in the file when it produces a certain result. How do I produce a script that will go to the next line in the text file using an If then statement

I'm assuming as you loop through, the task is conducting some kind of action with each result.

So,

Loop through each row in a CSV
If $result does not equal 'xyz'
conduct action
End if
End Loop

There are many variations of this, and many ways to create more complex rules. All depends on what you're trying to do.

[Bluemoon]

It's not the loop condition I have the problem with It's how do I get the CSV file to go to next row down in the Filedata() coloum I have specified ? IF I was using excel I would be simple to put in an 'enter' using the insert keystroke command to take to next row down once a certain condition is met

Thanks Anthony

[trentonponder]

Originally Posted by Bluemoon

It's not the loop condition I have the problem with It's how do I get the CSV file to go to next row down in the Filedata() coloum I have specified ? IF I was using excel I would be simple to put in an 'enter' using the insert keystroke command to take to next row down once a certain condition is met

Thanks Anthony

I'm confused, there are two things at play here.

1 - The source of the data - Are you getting this from a .csv file?
2 - Where you are placing that data - Where is this happening?

Filedata() is typically used when you're looping through the contents of a .csv file.

[Bluemoon]

Hi

I will try to expian what I mean a little better


1.The souce file is TXT.file
2. I then use the read from txt file comand and Filedata column (2) to get the information I want to loop
3. I then put that information into a web appilication and check it. When I get an error message on on the web application, that the information from the txt file is not valid I what to write a 'IF' statement so that when the error msessage occurs the next line in the column is pasted into the webpage and the loop can continue

[trentonponder]

Originally Posted by Bluemoon

Hi

I will try to expian what I mean a little better


1.The souce file is TXT.file
2. I then use the read from txt file comand and Filedata column (2) to get the information I want to loop
3. I then put that information into a web appilication and check it. When I get an error message on on the web application, that the information from the txt file is not valid I what to write a 'IF' statement so that when the error msessage occurs the next line in the column is pasted into the webpage and the loop can continue

I see. What I said in my original post still seems to be accurate for your case.

Read from .txt
Loop through values from .txt file
Test data in website
If result does not equal error
Perform action
End If
End Loop

The loop will automatically go on to the next line of your .txt file once it reaches 'end loop.' So long as you have the if statement surrounding the action it should work fine.

If you need further help, it would be best to post the task (or send privately if you don't want to post).

[Bluemoon]

I'm sorry but I'm still lost .

But loop works fine it's only when the error occus that the loop stops. It does not go to the next row in the column. I have put in an IF web control exists for when the error occurs I just want it to then put the next value in the loop in

[trentonponder]

Originally Posted by Bluemoon

I'm sorry but I'm still lost .

But loop works fine it's only when the error occus that the loop stops. It does not go to the next row in the column. I have put in an IF web control exists for when the error occurs I just want it to then put the next value in the loop in

That's exactly what it should be doing.
You could try error handling (if you have the right version of AA) but you shouldn't have to.

I'd have to see your task to determine where the error is.

[philkryder]

yes, if you can, please post a TEXT version instream for us to see.

[Bluemoon]

Hi I've attached a copy of scipt

Thanks for the help