I am looking for a way to say:

Based on the list here:

---------------------

Costco

Costco LLC

Costco Whls

Home Interiors Malaga

Home Plumbing

Home Property Management

Home Realty

Home Svc

These are unique business names:

---------------------

Costco

Home Interiors Malaga

Home Plumbing

Home Property Management

Home...

Thanks for reply.

The table that holds business names has 20M rows.

I can't specify a business name because I don't know it or will have to do it for every...

Alan,

Sorry for delay, but better later than never.

Thank you.

That is what I was looking for.

Eugene

Thanks, what if I need to change font-weight at <tr> level?

How do I access <tr>?

Thank you for reply,

So, for every <td>, if I need to change an attribute, I'd need to select 'td/@style' = ......?

Thanks,

Not sure why it doesn't make sense to you.

For instance you have a scheduled job that runs at 6PM daily. You have an automated email every morning reporting success/failure.

Then job...

Thanks Eugene and everyone else.

I have plenty of options now. I really like Eugene's example of using PARSENAME().

I think I am going to use it as it fits my case.

I...

Thank you for an example.

I ran it and I think I understand it, but my question still is: can you pick a value between 2 commas without hard-coding the length?

Could...

Thank you David,

I think your article is great, but I think it's to much for me to go through to be able to split 'A,B,C' without hardcoding positions.

what's 99 for?

What about any other error? There is no front end. The result is emailed to the user.

I guess what I am trying to do is to let the other 2...

Thanks for reply. By fails, I mean, the statement returns an error. Usually timeout error.

I believe the errors I am getting are related to the fact that I am importing a string in Czech Republic language.

What codepage do I use to load Czech?

Ok, I am trying to import a single row. I believe the data comes from Python, so I did change "row delimiter" to "LF", but ... same error about data...

I specified "text qualifier" as single quote and it understands it (I can see it in preview), but it won't load the data.

Keeps failing with the same msg