search in column

[usera]

Greeting,

I have a column based text file "FTPsitemap.txt" , like below

john,FTP1

Smith,FTP2

Ryan,FTP3

...

now I want to search the "FTPsitemap.txt", if found john, then give me FTP1;

                                                                    if I search Ryan, and find it then give me FTP3

                                                                    if searh TOM, can not find it then show error message

 

thanks

usera

 

[JohnOne]

That's a lovely story.

Get back to us when you've finished.

[Jos]

@usera,You have now created 2 threads and both is some sort of description of a problem and guess you are expecting now somebody to code a solution?

Won't happen! Show some effort in defining your questions and showing you have tried some code that isn't working properly yet.

Jos

 

[water]

I would start with _FileReadToArray to read the file into an array. Then loop through the array searching for the name.

[water]

That's a lovely story.

Get back to us when you've finished.

Lovely post, as always

[JohnOne]

In 8 years, this user has not posted a single effort of code.

[water]

If he hasn't changed his attitude in 8 years, why not just ignore him?

[Jos]

Guys, take this off-line please. Think I have been clear to the OP so lets see what happens.

Jos