Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm pulling book data from OCLC WorldCat which is uneven, at best, when it comes to the book Title. What I need is to identify the portion of the Title that is getting knocked into Column1.1 prior to Author and concat any found title chunks after the first Title line. I thought maybe I could use non-colon delimiters, but not all the title lines have punctuation. In this table I've split by the first colon. I've enclosed the same chunk of source text, below.
Column1.1 | Column1.2 |
Availability | Check the catalogs in your library. Libraries worldwide that own item: 7 Connect to the Penn Libraries catalog |
External Resources | Cite This Item |
Find Items About | Mayer, Christian,max: 29 |
Title | A letter from M. Christian Mayer, Astronomer to the Elector Palatine, to Mr. N.N. on the going of a new pendulum clock, made by Mr. John Arnold, and set up in the Elector's |
observatory at Manheim. (Translated from the German.). | |
Author(s) | Mayer, Christian, 1719-1783. |
Publication | London : Printed for T. Becket, |
Year | 1781 |
Description | viii, 19, [1] pages ; 4to |
Language | English |
Note(s) | Reproduction: Microfilm./ Woodbridge, CT/ Research Publications, Inc.,/ 1986./ 1 reel ; 35mm./ (The Eighteenth Century ; reel 6472, no. 05). |
Material Type | Microfiche (mfc); Microfilm (mfl) |
Document Type | Book |
Entry | 19850205 |
Update | 20160924 |
Accession No | OCLC: 224659971 |
Provider | OCLC |
Database | WorldCat |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
Availability | Check the catalogs in your library. Libraries worldwide that own item: 7 Connect to the Penn Libraries catalog |
External Resources | Cite This Item |
Find Items About | Mayer, Christian,max: 29 |
Title | Basis Palatina ... |
exeunte anno superiore 1762 ad norman Academiae regiae parisinae scientiarum exactam bis dimensa hoo demum anno 1763 novis mensuris aucta et confirmata recentissimisque observationibus et calculis | |
stabilita, | |
Author(s) | Mayer, Christian, 1719-1783. |
Publication | Mannhemii, ex Typographejo electorali-aulico |
Year | 1763 |
Description | 12 preliminary leaves, 23, [2] pages 23 cm |
Language | Latin |
SUBJECT(S) | |
Descriptor | Base measuring. |
Triangulation. | |
Base measuring. | |
Triangulation. | |
Note(s) | Half-title with vignette (12th preliminary leaf): Series et ordo triangulorum quae ex propriis suis observationibus anno 1763 habitis deduxit et correxit./ Head and tail |
pieces. | |
Class Descriptors | LC: QB303 |
Responsibility | a Christiano Mayer ... |
Document Type | Book |
Entry | 19891006 |
Update | 20150314 |
Accession No | OCLC: 23618319 |
Provider | OCLC |
Database | WorldCat |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
Availability | Check the catalogs in your library. Libraries worldwide that own item: 7 Connect to the Penn Libraries catalog |
External Resources | Cite This Item |
Find Items About | Mayer, Christian,max: 29 |
Title | Solis et lunae eclipseos observatio astronomica ... |
facta Schwezingae in specula nova electorali anno 1764 diebus 17 martii et 1 aprilis comparata pluribus Europae celebrioribus observationibus ejusdemque clementissimi principis honoribus oblata | |
quarto idus julii ejusdem anni / | |
Author(s) | Mayer, Christian, 1719-1783. |
Publication | Mannheimii : Ex typographejo electoraliaulico, |
Year | 1764 |
Description | [18], 70 pages : tables ; 23 cm |
Language | Latin |
SUBJECT(S) | |
Descriptor | Lunar eclipses -- 1764. |
Solar eclipses -- 1764. | |
Astronomy -- Early works to 1800. | |
Astronomy. | |
Lunar eclipses. | |
Solar eclipses. | |
Genre/Form | Early works. |
Time | 1764 |
Responsibility | a Christiano Mayer ... |
Document Type | Book |
Entry | 19831121 |
Update | 20161208 |
Accession No | OCLC: 10645217 |
Provider | OCLC |
Database | WorldCat |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
Availability: Check the catalogs in your library. Libraries worldwide that own item: 7 Connect to the Penn Libraries catalog
External Resources: Cite This Item
Find Items About: Mayer, Christian,max: 29
Title: A letter from M. Christian Mayer, Astronomer to the Elector Palatine, to Mr. N.N. on the going of a new pendulum clock, made by Mr. John Arnold, and set up in the Elector's
observatory at Manheim. (Translated from the German.).
Author(s): Mayer, Christian, 1719-1783.
Publication: London : Printed for T. Becket,
Year: 1781
Description: viii, 19, [1] pages ; 4to
Language: English
Note(s): Reproduction: Microfilm./ Woodbridge, CT/ Research Publications, Inc.,/ 1986./ 1 reel ; 35mm./ (The Eighteenth Century ; reel 6472, no. 05).
Material Type: Microfiche (mfc); Microfilm (mfl)
Document Type: Book
Entry: 19850205
Update: 20160924
Accession No: OCLC: 224659971
Provider: OCLC
Database: WorldCat
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Availability: Check the catalogs in your library. Libraries worldwide that own item: 7 Connect to the Penn Libraries catalog
External Resources: Cite This Item
Find Items About: Mayer, Christian,max: 29
Title: Basis Palatina ...
exeunte anno superiore 1762 ad norman Academiae regiae parisinae scientiarum exactam bis dimensa hoo demum anno 1763 novis mensuris aucta et confirmata recentissimisque observationibus et calculis
stabilita,
Author(s): Mayer, Christian, 1719-1783.
Publication: Mannhemii, ex Typographejo electorali-aulico
Year: 1763
Description: 12 preliminary leaves, 23, [2] pages 23 cm
Language: Latin
SUBJECT(S)
Descriptor: Base measuring.
Triangulation.
Base measuring.
Triangulation.
Note(s): Half-title with vignette (12th preliminary leaf): Series et ordo triangulorum quae ex propriis suis observationibus anno 1763 habitis deduxit et correxit./ Head and tail
pieces.
Class Descriptors: LC: QB303
Responsibility: a Christiano Mayer ...
Document Type: Book
Entry: 19891006
Update: 20150314
Accession No: OCLC: 23618319
Provider: OCLC
Database: WorldCat
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Availability: Check the catalogs in your library. Libraries worldwide that own item: 7 Connect to the Penn Libraries catalog
External Resources: Cite This Item
Find Items About: Mayer, Christian,max: 29
Title: Solis et lunae eclipseos observatio astronomica ...
facta Schwezingae in specula nova electorali anno 1764 diebus 17 martii et 1 aprilis comparata pluribus Europae celebrioribus observationibus ejusdemque clementissimi principis honoribus oblata
quarto idus julii ejusdem anni /
Author(s): Mayer, Christian, 1719-1783.
Publication: Mannheimii : Ex typographejo electoraliaulico,
Year: 1764
Description: [18], 70 pages : tables ; 23 cm
Language: Latin
SUBJECT(S)
Descriptor: Lunar eclipses -- 1764.
Solar eclipses -- 1764.
Astronomy -- Early works to 1800.
Astronomy.
Lunar eclipses.
Solar eclipses.
Genre/Form: Early works.
Time: 1764
Responsibility: a Christiano Mayer ...
Document Type: Book
Entry: 19831121
Update: 20161208
Accession No: OCLC: 10645217
Provider: OCLC
Database: WorldCat
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Any help is most apprciated!
Solved! Go to Solution.
Hi @appeljr ,
please find a possible solution in the file attached.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
So, is what you are importing essentially a text file formatted the way you have posted? @ImkeF might be able to assist.
Yes, @Greg_Deckler and @ImkeF : it's a plaintext file as formatted in the code box, and there's sadly no cleaner (fast) source for the kind of bulk pull I'm doing.
Hi @appeljr ,
please find a possible solution in the file attached.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Perfect! I've learned so much from your expertise!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.