Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • Reply To: Help Parsing String

    Yes, I searched and came across "Jeff Moden's infamous delimitedSplit8K function". I was looking for an alternative way.  I will implement Jeff Moden's infamous delimitedSplit8K function.  Thanks for the reply.

  • Reply To: Help Parsing String

    Correction I need help with also the first name because I'm getting the middle Initial in my first name results;Example First Name Results= John J

  • Reply To: Parse data from notes field

    Hey Phil,

    You are correct had 30,000+ records with the word "Responsibility" misspelled and 400+ spelled correctly.  Ran replace function to correct the misspelling.

    SELECT Pos1 = CHARINDEX('Total Paid amount is $',...

    • This reply was modified 2 years, 9 months ago by  Tav29.
  • Reply To: Parse data from notes field

    Fixed. Absolute Value (ABS)

  • Reply To: Parse data from notes field

    Phil,

    I'm getting this error. Here is my sql statement:

    SELECT Notes, NoteId

    ,TotalPaid = SUBSTRING(Notes, c.Pos1, c.Pos2 - c.Pos1)

    FROM dbo.NoteReceive

    CROSS APPLY

    (

    SELECT Pos1 = CHARINDEX('Total Paid amount...

  • Reply To: Parse data from notes field

    Never mind Phil, I got it. Thank you for your help.  also thank you Jonah.

  • Reply To: Parse data from notes field

    Thanks Phil,

    I'm sorry for such a novice question(New to SQL) I have this information in a Notes Field along with an ID Field in a table. How do I reference...

  • Reply To: Parse data from notes field

    Hi Phil,

    I'm trying to exact the Payment information (In Red). My problem is they all have different starting positions,  I did the Charindex recommend by Johan and I get 42,43,44,45,46...

  • Reply To: Parse data from notes field

    Thank you Johan,

    I tried the Charindex and I'm able to find the starting position. I have multiple positions 42,43,44,45,46.  What's the best way to go about this? a Case statement...

Viewing 9 posts - 1 through 9 (of 9 total)