Forum Discussion

comish4lif2's avatar
comish4lif2
Advocate II
3 years ago
Solved

Extract Text from Name of File being Imported

Is there an straightforward way in PQ or via a formula, new column, or measure to get the text from the name of the file being imported? Or do I have to redo a few things and reimport this as a ...
Need Help
  • Payeras_BI's avatar
    Payeras_BI
    3 years ago

    Hi,

    I understand your Source step equals to "Csv.Document(File.Contents(..."
    Copy paste the function below and invoke it in your Source instead.

     

    (Path as text) => 
let
FileName =  Text.BetweenDelimiters(Path, "_", ".txt", {0, RelativePosition.FromEnd}, 0),
Txt = Csv.Document(File.Contents(Path),[Delimiter=";", Encoding=1252, QuoteStyle=QuoteStyle.None]),
PromoteHeaders = Table.PromoteHeaders(Txt, [PromoteAllScalars=true]),
FileNameColumn = Table.AddColumn(PromoteHeaders, "FileName", each FileName)
in
FileNameColumn

     

    Hope it helps.

     

Payeras_BI's avatar
Payeras_BI
Solution Sage
3 years ago

Hi comish4lif2 ,

Assuming the file name is part of your Source step you could add a column extracting it using any of the functions you have available.

For instance: 

Text.BetweenDelimiters(Source,"\",".")

 

  • comish4lif2's avatar
    comish4lif2
    Advocate II
    3 years ago

    Is the file name part of my source step? 

    If I import a txt file, how do I get from "FIlename_06162023.txt" - to "06162023" in its own column.