Recent content by alexfwalker81

  1. A

    Help with Separating into Rows

    Thank you, this worked perfectly too.
  2. A

    Help with Separating into Rows

    Thank you, much appreciated!
  3. A

    Help with Separating into Rows

    No, it's something that I've been emailed I'm afraid.
  4. A

    Help with Separating into Rows

    What's normalizing the data?
  5. A

    Help with Separating into Rows

    Thanks Trevor, you're right, this would solve the problem. It is a one off job, but there are 3,000 lines in my file, which is why I've turned to Access as I can't do what you suggest 3,000 times! Appreciate I didn't indicate quite how big the file is in my original thread.
  6. A

    Help with Separating into Rows

    Sounds like exactly what I need, but I don't know how to write a function like that.
  7. A

    Help with Separating into Rows

    I have a table which has the following structure, where the Data column has pipe separated values which I need to separate into individual rows; SKUData N000702-EN-GB 105674|130351|14398|14421|19183|19184|19894|3692 N000542-EN-GB 17816|17817|17818|19303|21092 Plus many more...
  8. A

    Find and Replace

    Lightbulb moment. In my 'Subs' table, the final row was Null and Null. Having quickly imported it from Excel, I didn't notice the blank row in Excel, or once uploaded. I've just deleted that row and it seems to work perfectly. GPGeorge, I take your point in relation to simplification. I had to...
  9. A

    Find and Replace

    Of course, done.
  10. A

    Find and Replace

    Function FindAndReplace(strinput As Variant) As String Const FIND_REPLACE_VALUES As String = "SELECT [Target], [New target] FROM Subs;" If Len(strinput & vbNullString) = 0 Then Exit Function ' Bail if Null or empty string is passed With CurrentDb.OpenRecordset(FIND_REPLACE_VALUES)...
  11. A

    Find and Replace

    Thanks George, I realise the difficulty around substrings - I'm confident I've got this covered. I've changed 'input' to 'strinput' but just get 'Invalid use of Null' when I run it.
  12. A

    Find and Replace

    I'm having some issues compiling this - it doesn't like 'input'
  13. A

    Find and Replace

    Correct, it's not a frequent task. I'm in the process of a website migration where category URLs have changed from A to S, but not in a totally predictable way. I have a table which shows the old target URL and the new target URL, plus a table of old blog posts where the old target URLs exist...
  14. A

    Find and Replace

    I have two tables in my database, one with a long text field in which I'd like to perform a find and replace. However, the find and replace is not static. So in my second table, I have the values to find and the values to replace, e.g.; FindReplace AS BT CU DV EW How can I write...
  15. A

    Extracting a date from Short Text

    Thanks for your help with this. I tried both methods, just to see what happened and they both worked well.
See more
Back
Top Bottom